UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/NgcJ2xZeLNgfF6fsdpFl9WqCXjRUTi/qsblAguRGCs='
WHERE
key_id = 'd9979a4e5eb392483a0aa1411c1bcc5dad063300d156db55071a9ae635482fdb'
AND (
token = '/NgcJ2xZeLNgfF6fsdpFl9WqCXjRUTi/qsblAguRGCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)