UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '54TIibLpHaFd3zDv7azANduq1KzWw/Qy8ORK1/Yyz+8='
WHERE
key_id = '1ddcfe2c1c3c6991af4aa19eee50221359ce5524c33478301593d2c3d6029ace'
AND (
token = '54TIibLpHaFd3zDv7azANduq1KzWw/Qy8ORK1/Yyz+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)