UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't3JCoTGRnc5OYXkfITlsacD1QICns5fZamHxzWeEc9c='
WHERE
key_id = '0e6970f688cd39d6d98b90eaa7826fb884f87d05499370f17a67afbbf64637ea'
AND (
token = 't3JCoTGRnc5OYXkfITlsacD1QICns5fZamHxzWeEc9c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)