UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OqGqe5/KdAwv2hLJcCPPkjtRTwuMfimngF8yKUbiGeg='
WHERE
key_id = '9e32209a734f3353f8935f40174c613c80594df7f5a731613db2b451a6941ded'
AND (
token = 'OqGqe5/KdAwv2hLJcCPPkjtRTwuMfimngF8yKUbiGeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)