UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5IDkNzb8I2CvOd2CIUGIoNilNeHsPoh09LKxfA/lWlk='
WHERE
key_id = '5186303074b85ddb674d844e3fb26e9977936160d132a54144f94ec2027f4bc2'
AND (
token = '5IDkNzb8I2CvOd2CIUGIoNilNeHsPoh09LKxfA/lWlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)