UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzraCIWz2q9CJRyMSI4ZOzhqLieDgds4FaeOBo/o6LU='
WHERE
key_id = '7ae840199d333b6c2a941ffc99a37d42d3feb74220dcd797c6aecb4f489cbc82'
AND (
token = 'XzraCIWz2q9CJRyMSI4ZOzhqLieDgds4FaeOBo/o6LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)