UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xbso1YxJOOYh4khbHTKvO9pfRtROrMePMATCkklwgxQ='
WHERE
key_id = 'f6ad5916581122386cb34e2a2ee7f025d4e17cddac5032e8b8e9cad76ae30406'
AND (
token = 'Xbso1YxJOOYh4khbHTKvO9pfRtROrMePMATCkklwgxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)