UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i6dE3cmi6o1D7Kc78o3u3ofRS3x8Vr1TgftkI7F5H4k='
WHERE
key_id = 'fa4e5b3ed2c7b1b6c21699d31e82e16a45003adfbeded5e1fb52e314f945aeb1'
AND (
token = 'i6dE3cmi6o1D7Kc78o3u3ofRS3x8Vr1TgftkI7F5H4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)