UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UW/EkOQyEe0ZvljUwzttWHya7xOI4sN2CIa3kPK0Ap8='
WHERE
key_id = '02df56cb609d1e1f73ab73105808cc3ff0de8628a6ba7834bedd3ec52a5474b2'
AND (
token = 'UW/EkOQyEe0ZvljUwzttWHya7xOI4sN2CIa3kPK0Ap8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)