UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gbHwyi8Y0d1bErg3LjoqZwiq0seGSHtpMSzA6voITb4='
WHERE
key_id = '18780e90c38f30feec8798f1a4cb3dd7c2936495476350e358016a3a58029bda'
AND (
token = 'gbHwyi8Y0d1bErg3LjoqZwiq0seGSHtpMSzA6voITb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)