UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7nvRDm4BZGX7BcqzwJ9AOHfjIq8D80swlGUaRLEKWwA='
WHERE
key_id = '1fdfe5b6f8c4d346899a6af592341b8161c4eda5b496bd15c0c276b82979cb06'
AND (
token = '7nvRDm4BZGX7BcqzwJ9AOHfjIq8D80swlGUaRLEKWwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)