UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NgdMOMjFso3ThPy1jSnNqgy+bisKDZkpi5xuXiC5j+8='
WHERE
key_id = '9af5d9d38392624e8c1f0ab72b5d33065f3a787e0393f743e60aac1fd2bce7f4'
AND (
token = 'NgdMOMjFso3ThPy1jSnNqgy+bisKDZkpi5xuXiC5j+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)