UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IHnxxH6mUsej8nss7z2qXIdkH0Ce4HQciUktK7Cm/p4='
WHERE
key_id = '3c57887f834d405bfd778ac21977a25c9116c91cd6d0986849b0883374601059'
AND (
token = 'IHnxxH6mUsej8nss7z2qXIdkH0Ce4HQciUktK7Cm/p4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)