UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'opTE/z/7FLYjjEtt1eKfWzY8up4ehqKYPSD4gqpVI3I='
WHERE
key_id = 'd22ddad8bd8c95ad891103c2f159b8e6785dbd0030356aaf50ce334e2935dbce'
AND (
token = 'opTE/z/7FLYjjEtt1eKfWzY8up4ehqKYPSD4gqpVI3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)