UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YzhA8pyKJYwhMlAKWctvCMABZX+Ajz1NbDBt0Q+MOoA='
WHERE
key_id = '4d04facc8d77a9fe22c68d69fc20d694d0c2ec7a99fd4f94d71dbe5f0dc2f9b7'
AND (
token = 'YzhA8pyKJYwhMlAKWctvCMABZX+Ajz1NbDBt0Q+MOoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)