UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FhgE4dS4X/B7s47SnBvMxU9mTM7xtZPyQDC1Fl8YKp4='
WHERE
key_id = '6b1d3961c5f0529154d4223f053e37ea2d8cee1f182e0391595e558ad6922a01'
AND (
token = 'FhgE4dS4X/B7s47SnBvMxU9mTM7xtZPyQDC1Fl8YKp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)