UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gn5tcN439rlXyTsLDNbj4WtOjHBXY7QG0agZWz2j8sI='
WHERE
key_id = '74b16558e12a40e2a0a6653bf5779dd9bff3973290f40be9e282be8520579a70'
AND (
token = 'Gn5tcN439rlXyTsLDNbj4WtOjHBXY7QG0agZWz2j8sI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)