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