UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X/kRgkBijxCNJrzY1AV2vGmM5S6BEXDBe5TuAkGrE8o='
WHERE
key_id = '9a1b150b9704fc6ea0a8fbeec8fb8063f1a2427483510c71dc3c65ada002cee7'
AND (
token = 'X/kRgkBijxCNJrzY1AV2vGmM5S6BEXDBe5TuAkGrE8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)