UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nlWc/az5qyT+bj1htkX3l9WOhaYI7wtNspf8BOqCG1w='
WHERE
key_id = '9791e75c3ea6bb3bb06c25c1bb12794bfa8bb71457763172ad4861c4f18c79ca'
AND (
token = 'nlWc/az5qyT+bj1htkX3l9WOhaYI7wtNspf8BOqCG1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)