UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LKZCBq8FQjHUjzwGS8vlxwFeuQm/tmpWLIkP/f+LNp8='
WHERE
key_id = 'e7895bf844035dd4e44ba37b9a365713d5bd6fcb272f2f044f19888855494d5a'
AND (
token = 'LKZCBq8FQjHUjzwGS8vlxwFeuQm/tmpWLIkP/f+LNp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)