UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B0+Amxwta3Z7o5e9j2iZHQmYmQeO7Z6fhnx0IUJy5H4='
WHERE
key_id = '67d2ffef698da662dbbdf85d4632ef5a37a78638285ca2f7542919c4ef560bf1'
AND (
token = 'B0+Amxwta3Z7o5e9j2iZHQmYmQeO7Z6fhnx0IUJy5H4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)