UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r5XyXv3F/fykZFBRch3+fQ6Ktagt7xZJFRvVIt5FiXA='
WHERE
key_id = 'f407c1ddfcb2d6663f8e22810d4fd98221efa704fa68f6ddd1512369d622e7ea'
AND (
token = 'r5XyXv3F/fykZFBRch3+fQ6Ktagt7xZJFRvVIt5FiXA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)