UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vG656qWO9S1scJF8oF9qV47AOwS+aYQENSBIo3shLwE='
WHERE
key_id = '05b5db14f5ff46afe70aa0c880b41e37dfe6f98edf0761936b3423243f4c8ab1'
AND (
token = 'vG656qWO9S1scJF8oF9qV47AOwS+aYQENSBIo3shLwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)