UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1J+3gi1CQLatBI2r8yTFk1fC7iy4SnLo3qbWQA5NmxE='
WHERE
key_id = 'a3b48244b9018288e45b617400c12e52d82c02d3fe918669e6eb741a07db0970'
AND (
token = '1J+3gi1CQLatBI2r8yTFk1fC7iy4SnLo3qbWQA5NmxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)