UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2YViuhjndYw25SqbKHJ3S75iWXNewXu0lhOFpWU5YWI='
WHERE
key_id = '267a92a5707529a9c82365b6dc4c6c2538808b993f5a88d56550ff24f1d0780f'
AND (
token = '2YViuhjndYw25SqbKHJ3S75iWXNewXu0lhOFpWU5YWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)