UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IRv6OLsMiRbMFQdgGR4h4rfjp8Ro5LSuQVlK6IjMZlM='
WHERE
key_id = '648cb5f2b578bb9c683723202761ff05ae09810e91d4bb9a1a67e4d58ac2418e'
AND (
token = 'IRv6OLsMiRbMFQdgGR4h4rfjp8Ro5LSuQVlK6IjMZlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)