UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4rPiqMkRRSiJcg2lJw01TlT82tdklxBdqccdxybiS44='
WHERE
key_id = 'b4c62e7f7987c709043863514d90ba6468d81f79a5d7bcd83daedddb66e33168'
AND (
token = '4rPiqMkRRSiJcg2lJw01TlT82tdklxBdqccdxybiS44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)