UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yiIFWJ6chVlsHf8K5CkKGYQrf1oXEDtkE2sV7m8OQw4='
WHERE
key_id = '3c5dabeda62c7ce3cc26b7cd926202243a7a35e58a833a306e2ab9f4dbfc0dde'
AND (
token = 'yiIFWJ6chVlsHf8K5CkKGYQrf1oXEDtkE2sV7m8OQw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)